MySQL查询语句的执行顺序与SQL语句的书写顺序不同,本文整理了MySQL查询语句的实际执行顺序:FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY。
- FROM clause
- WHERE clause
- GROUP BY clause
- HAVING clause
- SELECT clause
- ORDER BY clause
该执行顺序整理自网络,MySQL-query-execution
一直想找一个权威的解释出处,比如官网,但没有找到,如果有人知道,欢迎留言。